MONTHWEEK

Returns the number of weeks in a specified month of specified year.

Syntax

MONTHWEEK(year_input, month_input, weekstart)

year_input the 4-digit year to be considered.

month_input the month (in numeric format) to be considered.

weekstart Optional. Default value is 1. Defines the first day of a week. Sunday is represented by a value of 1, and so on. Should be an integer between 1 and 7.

Remarks

• For weekstart, you can specify a cell (cell reference) that contains a number, a logical values, or text representations of numbers. Cells that contain error values or text that cannot be translated into numbers cause errors.
• If weekstart is not a whole number, then numbers are rounded to the nearest integer.

 

[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]